The quasiequational theory of relational lattices, in the pure lattice signature
نویسنده
چکیده
The natural join and the inner union operations combine relations in a database. Tropashko and Spight realized that these two operations are the meet and join operations in a class of lattices, known by now as the relational lattices. They proposed then lattice theory as an algebraic approach, alternative to the relational algebra, to the theory of databases. Litak et al. proposed an axiomatization in the signature extending the pure lattice signature with the header constant. They argued then that the quasiequational theory of relational lattices is undecidable in this extended signature. We refine this result by showing that the quasiequational theory of relational lattices in the pure lattice signature is undecidable as well. We obtain this result as a consequence of the following statement: it is undecidable whether a finite subdirectly-irreducible lattice can be embedded into a relational lattice. Our proof of this statement is a reduction from a similar problem for relation algebras and from the coverability problem of a frame by a universal product frame. As corollaries, we also obtain the following results: the quasiequational theory of relational lattices has no finite base; there is a quasiequation which holds in all the finite lattices but fails in an infinite relational lattice.
منابع مشابه
The equational theory of the natural join and inner union is decidable
The natural join and the inner union operations combine relations of a database. Tropashko and Spight [24] realized that these two operations are the meet and join operations in a class of lattices, known by now as the relational lattices. They proposed then lattice theory as an algebraic approach to the theory of databases, alternative to the relational algebra. Previous works [17, 22] proved ...
متن کاملRelational Lattices
Relational lattices are obtained by interpreting lattice connectives as natural join and inner union between database relations. Our study of their equational theory reveals that the variety generated by relational lattices has not been discussed in the existing literature. Furthermore, we show that addition of just the header constant to the lattice signature leads to undecidability of the qua...
متن کاملRelational lattices: From databases to universal algebra
Relational lattices are obtained by interpreting lattice connectives as natural join and inner union between database relations. Our study of their equational theory reveals that the variety generated by relational lattices has not been discussed in the existing literature. Furthermore, we show that addition of just the header constant to the lattice signature leads to undecidability of the qua...
متن کاملIdeal of Lattice homomorphisms corresponding to the products of two arbitrary lattices and the lattice [2]
Abstract. Let L and M be two finite lattices. The ideal J(L,M) is a monomial ideal in a specific polynomial ring and whose minimal monomial generators correspond to lattice homomorphisms ϕ: L→M. This ideal is called the ideal of lattice homomorphism. In this paper, we study J(L,M) in the case that L is the product of two lattices L_1 and L_2 and M is the chain [2]. We first characterize the set...
متن کاملT-Rough Sets Based on the Lattices
The aim of this paper is to introduce and study set- valued homomorphism on lattices and T-rough lattice with respect to a sublattice. This paper deals with T-rough set approach on the lattice theory. The result of this study contributes to, T-rough fuzzy set and approximation theory and proved in several papers. Keywords: approximation space; lattice; prime ideal; rough ideal; T-rough set; set...
متن کامل